IsAlertTriggered(alertName)

Basic and Crystal syntax.

Arguments

alertName is the name of an alert (in quotation marks) that you've already created.

Locate the available alerts in the Alert Names list, which appears in the Formula Editor's Functions tree once you've created an alert.

Returns

Boolean value indicating whether or not the alert is "triggered"—that is, whether or not the report data meets the alert condition formula.

Examples

Crystal syntax:

If IsAlertTriggered("myAlert") Then
    AlertMessage("myAlert")
Else
    "not triggered"

Basic syntax:

If IsAlertTriggered("myAlert") Then
    Formula = AlertMessage("myAlert")
Else
    Formula = "not triggered"
End If

Use this formula to display messages that let report users know which records have triggered the report alert. For instance, open the sample report called Alerting.rpt. Create the formula, replacing "myAlert" with "Sales" (which is the name of the alert in the sample report). Then drag the formula field into the Details section. (You might have to resize the Details section in order to see the formula field properly.) The formula displays the alert message for records that meet the alert conditions; otherwise, the formula displays your "not triggered" message.

Comment

Any formula that references an alert becomes a print time formula.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com